AchBatchFileCompanyDetail 
EntityType  Independent 
Logical Entity Name  AchBatchFileCompanyDetail 
Default Table Name  SaACHBatchCompanyDetail 
Logical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

AchBatchFileCompanyDetail Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
AchBatchFileCompanyDetailId(PK)    INTEGER  NO 
 
AchBatchFileCompanyHeaderId    INTEGER  NO 
 
StudentAccountTransactionId(FK)    INTEGER  NO 
 
TransactionCode    CHAR(2)  NO 
 
RecordDfiIdentifier    CHAR(8)  NO 
 
DfiAccountNumber    VARCHAR(100)  YES 
 
Amount    MONEY(19, 4)  NO 
 
AccountName    VARCHAR(22)  NO 
 
ResponseCode    CHAR(3)  YES 
 
NOCCode    CHAR(3)  YES 
 
CorrectedData    VARCHAR(29)  YES 
 
HoldStudentGroupId    INTEGER  YES 
 
TaskId    INTEGER  YES 
 
ResponseStudentAccountTransactionId    INTEGER  YES 
 
NSFApplied    INTEGER  YES 
 
BillingTransactionCodeId(FK)    INTEGER  YES 
 
ChargeAmount    MONEY(19, 4)  YES 
 
ResponseDate    DATETIME  YES 
 
CorrectedDFIAccountNumber    VARCHAR(50)  YES 
 
CorrectedRoutingNumber    VARCHAR(50)  YES 
 
CorrectedTransactionCode    VARCHAR(50)  YES 
 
RowVersion    TIMESTAMP/DATE  NO 
 
ScheduledDisbursementId(FK)    INTEGER  YES 
 
RefundId(FK)    INTEGER  YES 
 
InitializationVector    VARCHAR(100)  YES 
 
StudentGroupId(FK)    INTEGER  YES 
 

AchBatchFileCompanyDetail Keys 
Key Name  Key Type  Keys 
SaACHBatchCompanyDetail_SaACHBatchCompanyID_N_N_IDX  Inversion Entry  AchBatchFileCompanyHeaderId 
SaACHBatchCompanyDetail_SaACHBatchCompanyDetailID_U_C_IDX  PrimaryKey  AchBatchFileCompanyDetailId 

AchBatchFileCompanyDetail Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
BillingTransactionCode  Non-Identifying  Zero or One to Zero or More        BillingTransactionCodeId  NO 
StudentGroup  Non-Identifying  Zero or One to Zero or More        StudentGroupId  NO 
Refund  Non-Identifying  Zero or One to Zero or More        RefundId  NO 
StudentAccountTransaction  Non-Identifying  One To Zero or More        StudentAccountTransactionId  NO 
ScheduledDisbursement  Non-Identifying  Zero or One to Zero or More        ScheduledDisbursementId  NO 
StudentAccountTransaction  Non-Identifying  One To Zero or More        StudentAccountTransactionId  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 

AchBatchFileCompanyDetail Check Constraints 
Check Constraint Name  CheckConstraint 

AchBatchFileCompanyDetail Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.AchBatchFileCompanyDetail 
NO       
Physical (Microsoft SQL Server)
dbo.SaACHBatchCompanyDetail 
NO       

AchBatchFileCompanyDetail Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  ElectronicPaymentProcessing 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Student Accounts 

AchBatchFileCompanyDetail Data Movement Rules 
Name  Type  Rule Text/Value